package DB;

import Model.AttendanceView;
import java.util.ArrayList;
public interface AttendanceViewDBIF {

    public ArrayList<AttendanceView> getAllAttendanceViews(boolean retrieveAssociation);

    public ArrayList<AttendanceView> getAllAttendanceViewsBetweenDates(boolean retrieveAssociation,String startDate,String endDate);

    public ArrayList<AttendanceView> getAllAttendanceViewForOneStudentById(boolean retrieveAssociation,int studentId);

    public ArrayList<AttendanceView> getAllAttendanceViewForOneStudentByIdAndBetweenDates(boolean retrieveAssociation,int studentId, String startDate,String endDate);

    public ArrayList<AttendanceView> getAllAttendanceViewByCourse(boolean retrieveAssociation,int courseId);

    public ArrayList<AttendanceView> getAllAttendanceViewByStudentAndCourse(boolean retrieveAssociation,int studentId,int courseId);

    public ArrayList<Integer> getAllDistinctCoursesByStudentId(boolean retrieveAssociation,int studentId);

    public ArrayList<AttendanceView> getAllAttendanceViewByStudentAndCourseBetweenDates(boolean retrieveAssociation,int studentId,int courseId,String startDate,String endDate);

}
